if exists (select 1
            from  sysobjects
           where  id = object_id('Table_5')
            and   type = 'U')
   drop table Table_5
go

if exists (select 1
            from  sysobjects
           where  id = object_id('business')
            and   type = 'U')
   drop table business
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ygxx')
            and   type = 'U')
   drop table ygxx
go

if exists (select 1
            from  sysobjects
           where  id = object_id('yhxx')
            and   type = 'U')
   drop table yhxx
go

if exists (select 1
            from  sysobjects
           where  id = object_id('ywsq')
            and   type = 'U')
   drop table ywsq
go

/*==============================================================*/
/* Table: Table_5                                               */
/*==============================================================*/
create table Table_5 (
   
)
go

/*==============================================================*/
/* Table: business                                              */
/*==============================================================*/
create table business (
   id                   int                  not null,
   name                 nvarchar(80)         null,
   boss                 nvarchar(80)         null,
   num                  nvarchar(80)         null,
   email                nvarchar(80)         null,
   constraint PK_BUSINESS primary key (id),
   constraint AK_KEY_2_BUSINESS unique (boss)
)
go

/*==============================================================*/
/* Table: ygxx                                                  */
/*==============================================================*/
create table ygxx (
   name                 nvarchar(80)         not null,
   id                   id                   null,
   zhiwei               nvarchar(80)         null,
   num                  nvarchar(80)         null,
   monney               nvarchar(80)         null,
   constraint PK_YGXX primary key (name),
   constraint AK_KEY_2_YGXX unique (id)
)
go

/*==============================================================*/
/* Table: yhxx                                                  */
/*==============================================================*/
create table yhxx (
   id                   int                  not null,
   name                 nvarchar(80)         null,
   yhid                 nvarchar(80)         null,
   num                  nvarchar(80)         null,
   lxdz                 nvarchar(80)         null,
   constraint PK_YHXX primary key (id),
   constraint AK_KEY_2_YHXX unique (yhid)
)
go

/*==============================================================*/
/* Table: ywsq                                                  */
/*==============================================================*/
create table ywsq (
   id                   int                  not null,
   yid                  int                  null,
   hyrq                 date                 null,
   day                  int                  null,
   popel                int                  null,
   dd                   nvarchar(80)         null,
   ys                   int                  null,
   sl                   nvarchar(80)         null,
   constraint PK_YWSQ primary key (id)
)
go